package com.example.wxminiprogram.mapper;

import com.example.wxminiprogram.pojo.Shop;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ShopMapper {
    @Select("select * from shop where seller_id = #{seller_id}")
    List<Shop> getBySellerId(Integer seller_id);
    @Insert("insert into shop(seller_id) values (#{seller_id})")
    Integer insertBySellerId(Integer seller_id);
    @Select("select id from seller where account = #{account}")
    Integer getIdByAccount(String account);
}
